SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND p.iPostType=4 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=1 AND MATCH (t.strSearch) AGAINST ('+used +house +items +for +sale' IN BOOLEAN MODE)) AND iCityID IN (6043,6283,6256,6118,5926,5801,5538,5821,5461,5565,5785,5714,5476,6260,6112,6206,5662,5913,5888,5710,5487,6158,5823,5792,5496,5732,5866,5878,6216,6013,6295,5895,6161,5925,5529,5556,5815,5486,6218,28,5489,5687,16553,5645,5779,5507,5851,6233,6130,5892,6187,5905,6108,5929,6176,6290,5900,6111,5945,6282,5548,5613,6139,5935,5502,5995,5717,5751,5786,5733,6089,5842,5553,6210,5820,16368,5838,5969) ORDER BY FIELD(iCityID, 6043,6283,6256,6118,5926,5801,5538,5821,5461,5565,5785,5714,5476,6260,6112,6206,5662,5913,5888,5710,5487,6158,5823,5792,5496,5732,5866,5878,6216,6013,6295,5895,6161,5925,5529,5556,5815,5486,6218,28,5489,5687,16553,5645,5779,5507,5851,6233,6130,5892,6187,5905,6108,5929,6176,6290,5900,6111,5945,6282,5548,5613,6139,5935,5502,5995,5717,5751,5786,5733,6089,5842,5553,6210,5820,16368,5838,5969) ASC, p.tmPosted DESC LIMIT 24 used house items for sale, For Sale Classifieds, Buy Used, Electronics, Computers, Tablets, Mobiles in Pflugerville
logo

Pflugerville

Items for Sale

POST AD
Pflugerville
Items for Sale
All Items for Sale

Items for sale in Pflugerville - used house items for sale

Gallery Map
FAVORITE
Post Free Classified Terms of Use Privacy Policy RSS Feeds Submit Feed Email Alerts Mobile App Contact us Sitemap
Free Classifieds United States, ©Classi4U.com 2018-2024
By Using this website, you agree to Terms of Use & Privacy Policy. Got it